﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MesGLApp.DAL.MesDB
{
    [Serializable]
    [Table("source_prod_process")]
    public class SourceProdProcess
    {
        /// <summary>
        /// id，主键，自增长
        /// </summary>
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Column("id")]
        public int ID { get; set; }

        /// <summary>
        /// 客户代号
        /// </summary>
        [Column("client_code")]
        public string ClientCode { get; set; }

        /// <summary>
        /// 业务员
        /// </summary>
        [Column("saler_name")]
        public string SalerName { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        [Column("prod_number")]
        public string ProdNumber { get; set; }

        /// <summary>
        /// 生产订单号
        /// </summary>
        [Column("mo_number")]
        public string MoNumber { get; set; }

        /// <summary>
        /// 跟踪单号
        /// </summary>
        [Column("mto_number")]
        public string MtoNumber { get; set; }

        /// <summary>
        /// 成品代号
        /// </summary>
        [Column("goods_number")]
        public string GoodsNumber { get; set; }

        /// <summary>
        /// 成品名称
        /// </summary>
        [Column("goods_name")]
        public string GoodsName { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        [Column("goods_spe")]
        public string GoodsSpe { get; set; }

        /// <summary>
        /// 生产订单数量
        /// </summary>
        [Column("order_qty")]
        public decimal? OrderQty { get; set; }

        /// <summary>
        /// 长度
        /// </summary>
        [Column("goods_length")]
        public decimal? GoodsLength { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [Column("remark")]
        public string Remark { get; set; }

        /// <summary>
        /// 建档人
        /// </summary>
        [Column("create_user")]
        public string CreateUser { get; set; }


        /// <summary>
        /// 建档日期
        /// </summary>
        [Column("create_date")]
        public DateTime? CreateDate { get; set; }
    }
}
